{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7614a9b5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "import requests\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "payload = {\n",
    "    \"key\":\"b0121f143057c2f0c3607e48fe21bac9\",\n",
    "    \"address\":\"广东省广州市从化区广州南方学院\"\n",
    "}\n",
    "r = requests.get(url=geo_url, params=payload)\n",
    "广州南方学院_location = r.json()['geocodes'][0]['location']\n",
    "广州南方学院_location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "c1cee405",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'suggestion': {'keywords': [], 'cities': []},\n",
       " 'count': '355',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院后门润泰超市首层01-02号商铺',\n",
       "   'distance': '18',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '我家卖米粉(中大店)',\n",
       "   'location': '113.678455,23.628393',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRO7MT5G'},\n",
       "  {'parent': [],\n",
       "   'address': '博学路6号(广州南方学院南门口旁)',\n",
       "   'distance': '19',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.3',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '喜洋洋烧烤城',\n",
       "   'location': '113.678474,23.628422',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFKT56Q8'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇南方公寓',\n",
       "   'distance': '102',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;快餐厅;快餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050300',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': 'PROJECT.B美式汉堡(中大店)',\n",
       "   'location': '113.678983,23.627778',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCM4JK'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院',\n",
       "   'distance': '130',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.3',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '港式住家饭(中大店)',\n",
       "   'location': '113.679504,23.628108',\n",
       "   'tel': '13543496269',\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M90UGD'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方',\n",
       "   'distance': '146',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '找餐时间(轻食店)',\n",
       "   'location': '113.679695,23.628204',\n",
       "   'tel': '15918826460',\n",
       "   'shopid': [],\n",
       "   'id': 'B0H31YY48Q'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院',\n",
       "   'distance': '149',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '1号粥店',\n",
       "   'location': '113.679738,23.628307',\n",
       "   'tel': '18613024983',\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCMB8D'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方',\n",
       "   'distance': '150',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '巴老冒豆花冒菜(中大店)',\n",
       "   'location': '113.679739,23.628221',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCISXU'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院',\n",
       "   'distance': '156',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '牛哥烧烤',\n",
       "   'location': '113.679809,23.628326',\n",
       "   'tel': '18319344890;13822555954',\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCM3MH'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'distance': '167',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;快餐厅;快餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050300',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '十三幺熟食牛杂',\n",
       "   'location': '113.679565,23.627501',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G3ASF92M'},\n",
       "  {'parent': [],\n",
       "   'address': '广州南方学院西4123',\n",
       "   'distance': '209',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;快餐厅;快餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050300',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '香辣螺蛳粉',\n",
       "   'location': '113.676231,23.628565',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFKSF1FI'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇平岗村乌土平岗街29号',\n",
       "   'distance': '218',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.7',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '桃缘瓦舍',\n",
       "   'location': '113.680297,23.627788',\n",
       "   'tel': '13674002238',\n",
       "   'shopid': [],\n",
       "   'id': 'B0IGC5BQCT'},\n",
       "  {'parent': [],\n",
       "   'address': '乌土村中南公寓',\n",
       "   'distance': '231',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '歡喜烤鱼饭',\n",
       "   'location': '113.680349,23.627573',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCIT9Q'},\n",
       "  {'parent': [],\n",
       "   'address': '中南公寓首层022铺',\n",
       "   'distance': '231',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '过桥米线',\n",
       "   'location': '113.680349,23.627573',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H11HOB7J'},\n",
       "  {'parent': [],\n",
       "   'address': '中大南方学院后门',\n",
       "   'distance': '239',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.5',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '99BARBECUE烤吧(中大店)',\n",
       "   'location': '113.680449,23.629268',\n",
       "   'tel': '13538690052',\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCMIX1'},\n",
       "  {'parent': [],\n",
       "   'address': '笃行路20、22、24号广州南方学院商业中心1层1F015',\n",
       "   'distance': '257',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '【正常】全年10:00-23:00',\n",
       "    'rating': '4.1',\n",
       "    'open_time': '10:00-23:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;快餐厅;快餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/92eccba5b77ad95e40283c76afcc9d02'},\n",
       "    {'title': '菜品',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/dcc14003c07685599e7643a15d62ffe6'},\n",
       "    {'title': '菜品',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/adf960d539bff913f5fb8f1fc975015f'}],\n",
       "   'typecode': '050300',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '煌上煌酱鸭(广州南方学院店)',\n",
       "   'location': '113.679965,23.630156',\n",
       "   'tel': '13712317721',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFLF90I2'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院南门',\n",
       "   'distance': '257',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;韩国料理',\n",
       "   'photos': [],\n",
       "   'typecode': '050203',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '炸鸡队长(韩式炸鸡店)',\n",
       "   'location': '113.676603,23.630170',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFHVMT24'},\n",
       "  {'parent': [],\n",
       "   'address': '广州南方学院',\n",
       "   'distance': '261',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '09:00-23:00',\n",
       "    'rating': '4.5',\n",
       "    'open_time': '09:00-23:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;四川菜(川菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/20080ba9f6fcd2808d64ce149b517ca9'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/9f40694ca108a175d36847d03ecf4ec0'},\n",
       "    {'title': [],\n",
       "     'url': 'https://img.alicdn.com/imgextra/i2/3695320962/O1CN01JFnmLv1IydhNhdLT4_!!3695320962-0-kbcontentapng.jpg'}],\n",
       "   'typecode': '050102',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '重庆湖边纸包鱼',\n",
       "   'location': '113.679861,23.630285',\n",
       "   'tel': '13924024938',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFL7NUA2'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇乌土村上围2队13号',\n",
       "   'distance': '268',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '壹休盖饭',\n",
       "   'location': '113.679611,23.630517',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRHG0RSP'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇笃行路20、22、24号中山大学南方学院商业中心二楼022号',\n",
       "   'distance': '268',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '爱鱼者酸菜鱼饭(中大店)',\n",
       "   'location': '113.680193,23.630101',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M7009J'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州中大南方招待所中山大学南方学院',\n",
       "   'distance': '276',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;快餐厅;快餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050300',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '汉堡小亨(中大店)',\n",
       "   'location': '113.676765,23.630495',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M7Z0IF'}],\n",
       " 'status': '1',\n",
       " 'info': 'OK'}"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "around_url = 'https://restapi.amap.com/v3/place/around?parameters'\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"b0121f143057c2f0c3607e48fe21bac9\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"keywords\":\"美食\"\n",
    "}\n",
    "r = requests.get(around_url,params=payload)\n",
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "380c51a3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "688c40ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parent</th>\n",
       "      <th>address</th>\n",
       "      <th>distance</th>\n",
       "      <th>pname</th>\n",
       "      <th>importance</th>\n",
       "      <th>biz_type</th>\n",
       "      <th>cityname</th>\n",
       "      <th>type</th>\n",
       "      <th>photos</th>\n",
       "      <th>typecode</th>\n",
       "      <th>...</th>\n",
       "      <th>name</th>\n",
       "      <th>location</th>\n",
       "      <th>tel</th>\n",
       "      <th>shopid</th>\n",
       "      <th>id</th>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <th>biz_ext.opentime2</th>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <th>biz_ext.open_time</th>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院后门润泰超市首层01-02号商铺</td>\n",
       "      <td>18</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>我家卖米粉(中大店)</td>\n",
       "      <td>113.678455,23.628393</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HRO7MT5G</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>博学路6号(广州南方学院南门口旁)</td>\n",
       "      <td>19</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>喜洋洋烧烤城</td>\n",
       "      <td>113.678474,23.628422</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFKT56Q8</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.3</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇南方公寓</td>\n",
       "      <td>102</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050300</td>\n",
       "      <td>...</td>\n",
       "      <td>PROJECT.B美式汉堡(中大店)</td>\n",
       "      <td>113.678983,23.627778</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCM4JK</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院</td>\n",
       "      <td>130</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>港式住家饭(中大店)</td>\n",
       "      <td>113.679504,23.628108</td>\n",
       "      <td>13543496269</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M90UGD</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.3</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>146</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>找餐时间(轻食店)</td>\n",
       "      <td>113.679695,23.628204</td>\n",
       "      <td>15918826460</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H31YY48Q</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院</td>\n",
       "      <td>149</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>1号粥店</td>\n",
       "      <td>113.679738,23.628307</td>\n",
       "      <td>18613024983</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCMB8D</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>150</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>巴老冒豆花冒菜(中大店)</td>\n",
       "      <td>113.679739,23.628221</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCISXU</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院</td>\n",
       "      <td>156</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>牛哥烧烤</td>\n",
       "      <td>113.679809,23.628326</td>\n",
       "      <td>18319344890;13822555954</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCM3MH</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>167</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050300</td>\n",
       "      <td>...</td>\n",
       "      <td>十三幺熟食牛杂</td>\n",
       "      <td>113.679565,23.627501</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G3ASF92M</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[]</td>\n",
       "      <td>广州南方学院西4123</td>\n",
       "      <td>209</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050300</td>\n",
       "      <td>...</td>\n",
       "      <td>香辣螺蛳粉</td>\n",
       "      <td>113.676231,23.628565</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFKSF1FI</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇平岗村乌土平岗街29号</td>\n",
       "      <td>218</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>桃缘瓦舍</td>\n",
       "      <td>113.680297,23.627788</td>\n",
       "      <td>13674002238</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0IGC5BQCT</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.7</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[]</td>\n",
       "      <td>乌土村中南公寓</td>\n",
       "      <td>231</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>歡喜烤鱼饭</td>\n",
       "      <td>113.680349,23.627573</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCIT9Q</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[]</td>\n",
       "      <td>中南公寓首层022铺</td>\n",
       "      <td>231</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>过桥米线</td>\n",
       "      <td>113.680349,23.627573</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H11HOB7J</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>[]</td>\n",
       "      <td>中大南方学院后门</td>\n",
       "      <td>239</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>99BARBECUE烤吧(中大店)</td>\n",
       "      <td>113.680449,23.629268</td>\n",
       "      <td>13538690052</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCMIX1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[]</td>\n",
       "      <td>笃行路20、22、24号广州南方学院商业中心1层1F015</td>\n",
       "      <td>257</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050300</td>\n",
       "      <td>...</td>\n",
       "      <td>煌上煌酱鸭(广州南方学院店)</td>\n",
       "      <td>113.679965,23.630156</td>\n",
       "      <td>13712317721</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFLF90I2</td>\n",
       "      <td>[]</td>\n",
       "      <td>【正常】全年10:00-23:00</td>\n",
       "      <td>4.1</td>\n",
       "      <td>10:00-23:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院南门</td>\n",
       "      <td>257</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;韩国料理</td>\n",
       "      <td>[]</td>\n",
       "      <td>050203</td>\n",
       "      <td>...</td>\n",
       "      <td>炸鸡队长(韩式炸鸡店)</td>\n",
       "      <td>113.676603,23.630170</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHVMT24</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[]</td>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>261</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;四川菜(川菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050102</td>\n",
       "      <td>...</td>\n",
       "      <td>重庆湖边纸包鱼</td>\n",
       "      <td>113.679861,23.630285</td>\n",
       "      <td>13924024938</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFL7NUA2</td>\n",
       "      <td>[]</td>\n",
       "      <td>09:00-23:00</td>\n",
       "      <td>4.5</td>\n",
       "      <td>09:00-23:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇乌土村上围2队13号</td>\n",
       "      <td>268</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>壹休盖饭</td>\n",
       "      <td>113.679611,23.630517</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HRHG0RSP</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇笃行路20、22、24号中山大学南方学院商业中心二楼022号</td>\n",
       "      <td>268</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>爱鱼者酸菜鱼饭(中大店)</td>\n",
       "      <td>113.680193,23.630101</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M7009J</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州中大南方招待所中山大学南方学院</td>\n",
       "      <td>276</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050300</td>\n",
       "      <td>...</td>\n",
       "      <td>汉堡小亨(中大店)</td>\n",
       "      <td>113.676765,23.630495</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M7Z0IF</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   parent                            address distance pname importance  \\\n",
       "0      []        温泉镇中山大学南方学院后门润泰超市首层01-02号商铺       18   广东省         []   \n",
       "1      []                  博学路6号(广州南方学院南门口旁)       19   广东省         []   \n",
       "2      []                            温泉镇南方公寓      102   广东省         []   \n",
       "3      []                        温泉镇中山大学南方学院      130   广东省         []   \n",
       "4      []                            温泉镇中大南方      146   广东省         []   \n",
       "5      []                        温泉镇中山大学南方学院      149   广东省         []   \n",
       "6      []                            温泉镇中大南方      150   广东省         []   \n",
       "7      []                        温泉镇中山大学南方学院      156   广东省         []   \n",
       "8      []             温泉镇广州南方学院后门润泰超市1层05号商铺      167   广东省         []   \n",
       "9      []                        广州南方学院西4123      209   广东省         []   \n",
       "10     []                     温泉镇平岗村乌土平岗街29号      218   广东省         []   \n",
       "11     []                            乌土村中南公寓      231   广东省         []   \n",
       "12     []                         中南公寓首层022铺      231   广东省         []   \n",
       "13     []                           中大南方学院后门      239   广东省         []   \n",
       "14     []      笃行路20、22、24号广州南方学院商业中心1层1F015      257   广东省         []   \n",
       "15     []                      温泉镇中山大学南方学院南门      257   广东省         []   \n",
       "16     []                             广州南方学院      261   广东省         []   \n",
       "17     []                      温泉镇乌土村上围2队13号      268   广东省         []   \n",
       "18     []  温泉镇笃行路20、22、24号中山大学南方学院商业中心二楼022号      268   广东省         []   \n",
       "19     []               温泉镇广州中大南方招待所中山大学南方学院      276   广东省         []   \n",
       "\n",
       "   biz_type cityname                type  \\\n",
       "0     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "1     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "2     diner      广州市        餐饮服务;快餐厅;快餐厅   \n",
       "3     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "4     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "5     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "6     diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "7     diner      广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "8     diner      广州市        餐饮服务;快餐厅;快餐厅   \n",
       "9     diner      广州市        餐饮服务;快餐厅;快餐厅   \n",
       "10    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "11    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "12    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "13    diner      广州市  餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "14    diner      广州市        餐饮服务;快餐厅;快餐厅   \n",
       "15    diner      广州市      餐饮服务;外国餐厅;韩国料理   \n",
       "16    diner      广州市    餐饮服务;中餐厅;四川菜(川菜)   \n",
       "17    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "18    diner      广州市        餐饮服务;中餐厅;中餐厅   \n",
       "19    diner      广州市        餐饮服务;快餐厅;快餐厅   \n",
       "\n",
       "                                               photos typecode  ...  \\\n",
       "0                                                  []   050100  ...   \n",
       "1                                                  []   050100  ...   \n",
       "2                                                  []   050300  ...   \n",
       "3                                                  []   050100  ...   \n",
       "4                                                  []   050100  ...   \n",
       "5                                                  []   050100  ...   \n",
       "6                                                  []   050100  ...   \n",
       "7                                                  []   050118  ...   \n",
       "8                                                  []   050300  ...   \n",
       "9                                                  []   050300  ...   \n",
       "10                                                 []   050100  ...   \n",
       "11                                                 []   050100  ...   \n",
       "12                                                 []   050100  ...   \n",
       "13                                                 []   050118  ...   \n",
       "14  [{'title': [], 'url': 'http://store.is.autonav...   050300  ...   \n",
       "15                                                 []   050203  ...   \n",
       "16  [{'title': [], 'url': 'http://store.is.autonav...   050102  ...   \n",
       "17                                                 []   050100  ...   \n",
       "18                                                 []   050100  ...   \n",
       "19                                                 []   050300  ...   \n",
       "\n",
       "                  name              location                      tel shopid  \\\n",
       "0           我家卖米粉(中大店)  113.678455,23.628393                       []     []   \n",
       "1               喜洋洋烧烤城  113.678474,23.628422                       []     []   \n",
       "2   PROJECT.B美式汉堡(中大店)  113.678983,23.627778                       []     []   \n",
       "3           港式住家饭(中大店)  113.679504,23.628108              13543496269     []   \n",
       "4            找餐时间(轻食店)  113.679695,23.628204              15918826460     []   \n",
       "5                 1号粥店  113.679738,23.628307              18613024983     []   \n",
       "6         巴老冒豆花冒菜(中大店)  113.679739,23.628221                       []     []   \n",
       "7                 牛哥烧烤  113.679809,23.628326  18319344890;13822555954     []   \n",
       "8              十三幺熟食牛杂  113.679565,23.627501                       []     []   \n",
       "9                香辣螺蛳粉  113.676231,23.628565                       []     []   \n",
       "10                桃缘瓦舍  113.680297,23.627788              13674002238     []   \n",
       "11               歡喜烤鱼饭  113.680349,23.627573                       []     []   \n",
       "12                过桥米线  113.680349,23.627573                       []     []   \n",
       "13   99BARBECUE烤吧(中大店)  113.680449,23.629268              13538690052     []   \n",
       "14      煌上煌酱鸭(广州南方学院店)  113.679965,23.630156              13712317721     []   \n",
       "15         炸鸡队长(韩式炸鸡店)  113.676603,23.630170                       []     []   \n",
       "16             重庆湖边纸包鱼  113.679861,23.630285              13924024938     []   \n",
       "17                壹休盖饭  113.679611,23.630517                       []     []   \n",
       "18        爱鱼者酸菜鱼饭(中大店)  113.680193,23.630101                       []     []   \n",
       "19           汉堡小亨(中大店)  113.676765,23.630495                       []     []   \n",
       "\n",
       "            id biz_ext.cost  biz_ext.opentime2 biz_ext.rating  \\\n",
       "0   B0HRO7MT5G           []                 []             []   \n",
       "1   B0FFKT56Q8           []                 []            2.3   \n",
       "2   B0HROCM4JK           []                 []             []   \n",
       "3   B0H1M90UGD           []                 []            3.3   \n",
       "4   B0H31YY48Q           []                 []             []   \n",
       "5   B0HROCMB8D           []                 []             []   \n",
       "6   B0HROCISXU           []                 []             []   \n",
       "7   B0HROCM3MH           []                 []             []   \n",
       "8   B0G3ASF92M           []                 []             []   \n",
       "9   B0FFKSF1FI           []                 []             []   \n",
       "10  B0IGC5BQCT           []                 []            3.7   \n",
       "11  B0HROCIT9Q           []                 []             []   \n",
       "12  B0H11HOB7J           []                 []             []   \n",
       "13  B0HROCMIX1           []                 []            3.5   \n",
       "14  B0FFLF90I2           []  【正常】全年10:00-23:00            4.1   \n",
       "15  B0FFHVMT24           []                 []            3.9   \n",
       "16  B0FFL7NUA2           []        09:00-23:00            4.5   \n",
       "17  B0HRHG0RSP           []                 []             []   \n",
       "18  B0H1M7009J           []                 []             []   \n",
       "19  B0H1M7Z0IF           []                 []             []   \n",
       "\n",
       "   biz_ext.open_time biz_ext.meal_ordering  \n",
       "0                 []                     0  \n",
       "1                 []                     0  \n",
       "2                 []                     0  \n",
       "3                 []                     0  \n",
       "4                 []                     0  \n",
       "5                 []                     0  \n",
       "6                 []                     0  \n",
       "7                 []                     0  \n",
       "8                 []                     0  \n",
       "9                 []                     0  \n",
       "10                []                     0  \n",
       "11                []                     0  \n",
       "12                []                     0  \n",
       "13                []                     0  \n",
       "14       10:00-23:00                     0  \n",
       "15                []                     0  \n",
       "16       09:00-23:00                     0  \n",
       "17                []                     0  \n",
       "18                []                     0  \n",
       "19                []                     0  \n",
       "\n",
       "[20 rows x 24 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "807f2cc7",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
